﻿CREATE TABLE [dbo].[Books]
(
	BookID int primary key, 
	DocTypeID int null references DocTypes(DocTypeID),
	AuthorTypeID int references AuthorTypes(AuthorTypeID),
	
	BookName nvarchar(250) NOT NULL,
	TitlePageIndex smallint NOT NULL,
	Publisher nvarchar(100) NULL,
	PublicationPlace nvarchar(80) NULL,
	LanguageID int references Languages(LanguageId) NULL,
	PublicationYear int NULL,
	Size nvarchar(50) NULL,
	ISBN nvarchar(64) NULL,
	ISSN nvarchar(32) NULL,
	Annotation nvarchar(4000) NULL,
	ResponsibilityStatements nvarchar(250) null,
	NameExtraInfo nvarchar(250) null,
	ParallelName nvarchar(250) null,
	PublicationInfo nvarchar(64) null,
	PartIndex int null,
	PartName nvarchar(250) null,
	PublicationStartYear int null,
	PublicationFinishYear int null,
	SeriesName nvarchar(250) null,
	ParallelSeriesName nvarchar(250) null,
	SeriesInfo nvarchar(250) null,
	SeriesResponsibilityInfo nvarchar(250) null,
	SeriesNumber int null,
	SeriesISSN nvarchar(32) null,
	SubSeriesName nvarchar(250) null,
	SubSeriesNumber int null,
	Illustrations nvarchar(150) null,
	Bibliography nvarchar(150) null,
	SupportMatherials nvarchar(250) null,
	CommonRemarks nvarchar(250) null,

	DzcFileLocation nvarchar(400) NOT NULL,
	InputFilesFolder nvarchar(100) NULL
)